Restore non-critical Oracle files, redo, temporary files, index files, and password files
The Application of Incremental backup is in the rediscovery stage and is no longer in the restore stage.
Learn about the database settings t
1. Recover control files from automatic backup using Rman (without Fra)
ORACLE will default to create server parameter files and control files in the $oracle_home/dbs or $ORACLE _home/database directory.
Assuming that the instance parameter file has been restored and the instance is started, the general process of restoring the control file is to set up Oracle_
.Restore and restore the missing data files.
5. Open the database.
1. Full recovery of non-critical data files lost in archive Mode
Method 1:
Shutdown abort;
Startup mount;
Alter database create datafile '/home/oracle/test. dbf' as '/home/oracle/test. dbf ';
Recover datafile;
Method 2:
Create tablespace test datafile '
:/oracle1/ora81/database> exit
Back up control files with to trace
SQL> alter Database Backup controlfile to trace;
Database altered.
SQL> shutdown immediate
ORA-01109: Database not open
Database dismounted.
Oracle instance shut down.
SQL>
Find the control file and edit it.
Startup nomount
Create controlfile reuse Database "backup" noresetlogs archivelog
Maxlogfiles 32
Maxlogmembers 2
Maxdatafiles 254
Maxinstances 1
# Maxloghistory 453
Logfile
Gro
1, in the computer installation "Easyrecovery" and then we open the Easyrecovery software, then in the open interface we choose Media Type: storage devices.
Figure 1: Selecting a Media type
2, find our U disk, such as our U disk is: E disk.
Figure 2: Select the volume label you want to scan
3, select the recovery scenario: Recover deleted files.
4, check your options.
5, save the file.
Note: U disk data has been mistakenly
When there is a built-in SD card and the shared SDcard feature is not turned on, some customer resources need to be provisioned in the SD card.These resources end user visible and can also be deleted. After the resource has been deleted by user, the factory reset function is performed and the provisioned resources need to be restored.1. Pre-provision the same resources to user-invisible partitions, such as/system.Create a directory under Alps\vendor\mediatek\project_name\artifacts\out\target\pro
ORACLE does not have parameter files and control files. How can I restore databases through rman?Scenario: a dev tells me that a user's table cannot be seen in the production environment and needs to be restored. At this time, the disk directory file of the parameter file control file that is automatically backed up in the production database is broken, therefore
Recover data: Restore deleted files in LinuxRecover data: Restore deleted files in LinuxGuideHave you ever encountered such a thing? When you find out, you have deleted the key or usedThe "rm" command mistakenly deletes an object that should not be deleted.
In the first case, you can go to the garbage bin, search for t
When managing databases and systems, we often need to delete rm files. Since there is no Recycle bin in Linux, after rm deletes a file or directory, data cannot be found and recovered from the so-called recycle bin in Windows. In this case, after the data is deleted by mistake, we usually need to back up the data or find a data recovery company to restore our database and system management, you often need t
MSSQL Server 2005 Restore Database Bak files, Web sites using Virtual host site will often encounter, in general, the host has an online management program, but sometimes not, you need to restore the local backup SQL database. In this case, MSSQL Server 2008 will also appear, sometimes the "backup set of database backup and the existing XX database is different"
/sha256 Signature, key ID fd431d51: NokeyPreparing ... ########################################### [100%]1:e2fsprogs-devel ########################################### [100%][[email protected] extundelete-0.2.4]# make #编译 to compile the source code into an executable binary file.-j 4 compiles at the same time using the 4 process, increasing the compilation speed or compiling with the 4-core CPU at the same time.[[email protected] extundelete-0.2.4]# make install #安装Start recovery:Method 1:
system disk, select " Restore only previous versions of Files "), disk space size, and then press " apply " and " OK " to exit.
Put
this picture away.
expand this picture
Finally, set an identity for the restore point. Press "Create" to enter a name in the Restore Point c
In CentOS, if a file is accidentally deleted, perform the following steps to restore the file. 1. disable all services. when files are deleted by mistake, in order to restore data as much as possible, you must first disable all ongoing services and avoid data writing, otherwise, the probability of recovery is lower. We can directly # killall process name or # kil
Restore accidentally deleted files in CentOS
In CentOS, if a file is accidentally deleted, perform the following steps to restore the file.
1. Disable all services
When a file is accidentally deleted, in order to restore data as much as possible, you must first disable all ongoing services and do not write data. Other
Original article. Please indicate the source for reprinting. Thank you!Author: Qinglin, blog name: feikong jingdu
Today, I am testing the code I just completed for backing up and recovering NTFS partitions in Linux. I am running a program to back up a m NTFS partition, then, after running another program to restore data to the MB partition, load the partition to/tmp/sdd1 to check whether the file is successfully restored.-I'm glad that it took a few
How to restore files backed up with "Easy backup" in the Win10 system, win10 easy backup
In the article "how to back up files in Windows 10 System", I explained the file backup method, But how should I restore the files backed up with the "Easy backup" software? This articl
Non-critical data file loss (offline data files can be lost): run {sqlalterdatabasedatafileoffline; restoredatafile; recoverdatafile; slqalterdatabasedatafileonline ;} in addition to the system and undo_tablespace parameters, the tablespace corresponding to the values can be restored using the preceding methods. [Limit L
Non-critical data file loss (offline data files can be lost): run {SQL alter database d
Some important files were accidentally deleted yesterday. after about one day of recovery, rm was successfully restored. Here we will summarize the methods. Of course, it is the most important to prevent this situation. you can refer to the Linux RM Security recovery conditions and some preparations previously written: 1. data protection. Common sense: after a file is deleted, the file content is not cleared,
Some important
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.